{% extends "base.html" %}
{% block content %}
{% ifequal is_con 0 %}
<script type="text/javascript" src="/static/js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="/static/js/jquery-ui-1.8.16.custom.min.js"></script>
<link href="/static/css/jquery-ui-1.8.16.custom.css" rel="stylesheet" type="text/css" />
<div class="form-div" style="margin:10px;">
  <form action='' method='get' name="searchForm">
	<table>
		<tr>
			<td style="border:0px;padding:3px;">
				<img src="/static/images/icon_search.gif" width="26" height="22" border="0" alt="SEARCH">
			</td>
			<td  style="border:0px;padding:3px;">
				Date Start:<input type='text' name='starttime' id='start'>
				Date End:<input type='text' name='endtime' id='end'>
				Program:<select name="p_id" id="p_id" style="color:#CC33FF" onchange='$("input#search").click()'>
							{% for p in project_list %}
								<option value="{{p.id}}" {% ifequal p.id p_id %} selected="selected" {% endifequal %}>{{p.name}}</option>
							{% endfor %}
							</select>
				<input type='button' id="search" value='Search'/>
			</td>
		</tr>
		<tr style="display:none;">
			<td style="border:0px;padding:3px;"></td>
			<td colspan='10' style="border:0px;padding:3px;">
				<div class="selectdate" days='7'>Weekly</div>
				<div class="selectdate" days='14'>Bi-weekly</div>
				<div class="selectdate" days='30'>Monthly</div>
				<div class="selectdate" days='90'>Season</div>
				<div class="selectdate" days='180'>Half-yearly</div>
				<div class="selectdate" days='365'>Yearly</div>
			</td>
		</tr>
	</table>
  </form>
  <form action="/report_export/" method='post' id='post_report'>
	<input type='hidden' name='d' value=''/>
	<input type='hidden' name='t' value=''/>
  </form>
</div>
<script type="text/javascript" src="/static/js/create_report_export.js"></script>
<script>
$(document).ready(
	function(){
    	$('#start').datepicker({"dateFormat": "yy-mm-dd",changeMonth:true,changeYear:true})
		$('#end').datepicker({"dateFormat": "yy-mm-dd",changeMonth:true,changeYear:true})
		var d = new Date();
		var agodays = d.getFullYear().toString()+'-01'+'-01';
		$('#start').val(agodays)

		$('div.selectdate').click(function(){
			$('div.selectdate').css('background','')
			$(this).css('background','#defdef')
			var days = parseInt($(this).attr('days'))
			var agodays = new Date(Date.parse(new Date().toString()) - 86400000*days);

			var year = agodays.getUTCFullYear()
			var month = (agodays.getUTCMonth()+1)>=10?(agodays.getUTCMonth()+1):'0'+(agodays.getUTCMonth()+1)
			var day = agodays.getUTCDate()>=10?agodays.getUTCDate():'0'+agodays.getUTCDate()
			var date = year+'-'+month+'-'+day
			$('#start').val(date)
			$('#end').val('')
			$("input#search").click()
		})
		
	}
)


$("input#search").bind({
	click:function(){
		var t = this
		if(t.style.cursor == 'wait'){
			return false;
		}
		t.style.cursor = 'wait'
		var data = $('form[name="searchForm"]').serializeArray()
		var datas = {'is_con':1,'t':Math.random()}
		for(var i=0;i<data.length;i++){
			datas[data[i].name] = data[i].value
		}
		$.ajax({
			url:'',
			data:datas,
			type:'get',
			dataType:'html',
			success:function(e){
				t.style.cursor = 'pointer'
				$('#conreturn').html(e)
			}
		})
	}
})
</script>
{% endifequal %}
<style>
td{
	padding:2px;
	border:1px dotted #333;
}
th{
	background:#D0E6E3;
	border:1px dotted #333;
	padding:2px;
}
.selectdate{
	width:auto;float:left;padding:3px;background:#fff;border:1px dotted #333;margin:2px;cursor:pointer;
}
.selectdate:hover{
	background:#defdef;
}
.gray{
	color:gray;
}
</style>
<div id="conreturn" style="margin:10px;">
	{%if error_info%}
		<span class='red'>{{error_info}}</span>
	{%else%}
	<table width='90%'>
		<tr>
			<td colspan="200"  style="border:1px solid #333;">
				<table width='100%'>
				  <tr>
					<td colspan='2' align='left' style="line-height:25px;background:#ffffcd;border:0px;padding:3px;"></td>
					<td align='right' colspan='5' align='right' style="line-height:25px;background:#ffffcd;border:0px;padding:3px;">
						<strong><span id='university'></span></strong><br>
						<strong><span id='program'></span></strong>
					</td>
				  </tr>
				  <tr>
					<td colspan='2' align='left' style="line-height:25px;background:#ffffcd;border:0px;padding:3px;font-size:20px;"><strong id='report_title'>Class Size Forecast</strong></td>
					<td colspan='2' align='left' style="line-height:25px;background:#ffffcd;border:0px;padding:3px;"><span class='gray'>Program:</span><strong id="show_pragram"></strong></td>
					<td colspan='14' align='right' style="line-height:25px;background:#ffffcd;border:0px;padding:3px;"><strong>Date:</strong>&nbsp;
					<span id="report_start">{{begin|date:"M d,Y"}}</span> - {{end|date:"M d,Y"}}</td>
				  </tr>
				</table>
			</td>
		</tr>
		<tr>
			<th rowspan='2' valign='middle' width="100">Modules</th>
			<th rowspan='2' valign='middle' width='60'>C / E</th>
			<th rowspan='2' valign='middle' width='100'>Class Date</th>
			{%for d in tolmonth%}
				<th colspan='{{d.length}}'>{{d.year}}</th>
			{%endfor%}
		</tr>
		<tr>
			{%for d in tolmonth%}
				{%for y in d.value%}
				<th>
					{%ifequal y 1%}Jan{%endifequal%}
					{%ifequal y 2%}Feb{%endifequal%}
					{%ifequal y 3%}Mar{%endifequal%}
					{%ifequal y 4%}Apr{%endifequal%}
					{%ifequal y 5%}May{%endifequal%}
					{%ifequal y 6%}Jun{%endifequal%}
					{%ifequal y 7%}Jul{%endifequal%}
					{%ifequal y 8%}Aug{%endifequal%}
					{%ifequal y 9%}Sep{%endifequal%}
					{%ifequal y 10%}Oct{%endifequal%}
					{%ifequal y 11%}Nov{%endifequal%}
					{%ifequal y 12%}Dec{%endifequal%}
				</th>
				{%endfor%}
			{%endfor%}
		</tr>
		{%if static_ret%}
		{%for sta in static_ret%}
		<tr>
			<td align='center'>{{sta.name}}</td>
			<td align='center'>{{sta.ce}}</td>
			<td align='center'>
				{%if sta.date1%}{{sta.date1|date:"M d,Y"}}<br>{%endif%}
				{%if sta.date2%}{{sta.date2|date:"M d,Y"}}<br>{%endif%}
				{%if sta.date3%}{{sta.date3|date:"M d,Y"}}<br>{%endif%}
				{%if sta.date4%}{{sta.date4|date:"M d,Y"}}<br>{%endif%}
				{%if sta.date5%}{{sta.date5|date:"M d,Y"}}<br>{%endif%}
			</td>
			{%for v in sta.value%}
				<td align='center'>{{v}}</td>
			{%endfor%}
		</tr>
		{%endfor%}
		{%else%}
		<tr>
			<td colspan='1000'  align="center"><span style="color:green;font-size:16px;line-height:30px;">No Result!</span></td>
		</tr>
		{%endif%}
	</table>
	{%endif%}
</div>
{{ttt}}
<script>
$('#show_pragram').text($('#p_id option:selected').text())
var pro = parseInt($('#p_id').val())
if(school[pro]!=undefined){
	$('#university').text(school[pro][0])
	$('#program').text(school[pro][1])
}
</script>
{% endblock %}
